<?php //echo '<pre>'; print_r($projects) ?>
<link rel="stylesheet" type="text/css" href="<?php echo base_url() ?>/public/style.css"> 
<div class="header-title">Tables</div>
<table class="list">
    <tr>
        <th>No</th>
        <th>Query Name</th>
        <th>Query Description</th>
        <th>Query SQL</th>
        <th>Action</th>  
    </tr>
    <?php foreach($queries as $key => $query): ?>
    <tr>
        <td><?php echo $key+1 ?></td>
        <td><?php echo $query->query_name ?></td>
        <td><?php echo $query->query_description ?></td>
        <td  width="700px"><?php echo $query->query_sql ?></td>
        <td>
            <a href="<?php echo base_url() ?>index.php/queries">Edit</a>
        </td>
    </tr>
    <?php endforeach; ?>
</table>